USE siscon;
GO

create unique nonclustered index idx_user_1 on sis_user(login_name);
GO

create unique nonclustered index idx_teacher_1 on sis_teacher(school_id);
GO

create unique nonclustered index idx_classroom_1 on sis_classroom(classroom_location, classroom_number);
GO